Renaming Tables.

Dear All,

I've been renaming some of my tables with alter table.  These tables were
created with a primary key so an implicit unique index is created on the
primary key field.

When I rename the table, the <old_table_name>_pkey is not renamed but the
key still appears to function normally (e.g. I can't insert two entries
with the same primary key).

Are they any instances (other than 'human' ones such as lack of clarity in
table names) where this might be a problem or can I safely ingnore the
discrepancy.

Cheers,

S.


+-------------------------+--------------------------------------+
| Stuart Rison            | Ludwig Institute for Cancer Research |
+-------------------------+ University College London            |
| Tel. (0171) 878 4041    | 91 Riding House Street               |
| Fax. (0171) 878 4040    | London, W1P 8BT, UNITED KINGDOM.     |
+-------------------------+--------------------------------------+
| stuart@NOJUNK_ludwig.ucl.ac.uk [Remove NOJUNK_ for it to work] |
+----------------------------------------------------------------+